from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey
from sqlalchemy.orm import registry
mapper_registry = registry()
Base = mapper_registry.generate_base()



class Jobs(Base):
    __tablename__ = "jobs"
    j_id = Column(String(11), primary_key=True)
    j_name = Column(String(30))
    duty = Column(String(125))
    ask = Column(String(125))




    def __init__(self,j_id=None,j_name =None,duty=None,ask=None):
        self.j_id = j_id
        self.j_name = j_name
        self.duty = duty
        self.ask = ask

    def format_str(self):
        return self.j_id + "," + self.j_name + "," + self.duty + "," + self.ask


